Create table PowersportsVehicle.PowersportsVehicleInfo
(
PowersportsVehicle_InfoID int identity(1,1) primary key,
AutoAccessoryProductType_InfoID int not null,
 PowersportsVehicleVariationData_InfoID int not null,
 ModelYear int ,
 Season nvarchar(50),
 PowersportsVehicleColorSpecification_InfoID int,
 ManufacturerWarrantyDescription nvarchar(50) ,
 OEManufacturer nvarchar(50),
 IsDel bit default 0,
CreateUser nvarchar(20) default 'PU',
CreateTime datetime default getdate(),
UpdateUser nvarchar(20) default 'FL',
UpdateTime datetime default getdate()
)

Create table  PowersportsVehicle.PowersportsVehicleVariationDataInfo
(
PowersportsVehicleVariationData_InfoID int identity(1,1) primary key,
Parentage nvarchar(6) not null,
VariationTheme nvarchar(10) not null,
IsDel bit default 0,
CreateUser nvarchar(20) default 'PU',
CreateTime datetime default getdate(),
UpdateUser nvarchar(20) default 'FL',
UpdateTime datetime default getdate()
)

Create table PowersportsVehicle.PowersportsVehicleColorSpecificationInfo
(
PowersportsVehicleColorSpecification_InfoID int identity(1,1) primary key,
Color nvarchar(50),
ColorMap nvarchar(50),
IsDel bit default 0,
CreateUser nvarchar(20) default 'PU',
CreateTime DATETIME DEFAULT GETDATE(),
UpdateUser nvarchar(20) default 'FL',
UpdateTime datetime default getdate()
)